CREATE OR REPLACE PACKAGE "kesplus_platform"."kes_plus_pkg_sys_user_role" AUTHID CURRENT_USER AS
    function add(jsonData text) return json;
    function del(id_ varchar,userid varchar) return json;
    function update(jsonData text) return json;
    TB_NAME VARCHAR := 'kes_sys_users_roles';
    PK_COLUMN_NAME VARCHAR := 'id';
    procedure check_unique(jsonData varchar,count_ integer);
    function page_kes_sys_user(page integer, size integer,blurry character varying,appId varchar) return json;
end;

CREATE OR REPLACE PACKAGE BODY "kesplus_platform"."kes_plus_pkg_sys_user_role" AS WRAPPED
iDTzl03rSnVne/967IAocQMAoL9kVG+88OQhfa8kKfA4eok2AxbAai8ic2Js
UkCJ0IG0w9gfFQBq0aS/1uCDV3sIcqIWE9gs+aWaMLwtsmPXN6YisGWT0G2E
uHgmM5Fo97AHxYDgxmVZf2utQxFYZIXFX5d+/qPPlvdlHizO8wZ9CmHFrzSz
Lj9uZdzDGwialrPKsvnYwq5hBSK6Lx/Ii+zb3MwdSgPGVzvrhg5z+c7cKBtM
QJl39A7Yp14cr/4jv1/MsWxZmSaSrRh0ily9RzELqN/Ruif0kiXJITAKBXrA
JEux1F8NFX9IP2uZgb2C729fzDQ2OfqppMahGdS0PHvD6P9gGswhnwGoLMuz
K5rBpbRggILo29uviwogZZYnFWbHdRhUBxJYjMkoXsbP4dE/1v6dTFejAJng
dS+0XbSOE9gZ6FP7d8hR9jDRu5+wq9ms4BxYBSfLogQjUL5EZohb3iLsVr/Z
vGw9sv6mG4lIDLt5CV93WwcLMEGTdWbePASLwhzEamscXPrIgHFNmFNg8VsK
6h+M2rX/3ojl2DQU5PQZShj0bd3VdY2os6IFcitL7lo+fktBPzlaM/ZV+83h
aONllw3XCrqG9m1IMofdnYYaZhaeLZOdUXgDXody7XfzrKETxzZ6yH0agG/u
K+QHbNPZEB1VDwSEtODWCVHQFaaezsHsJt3B59uA0LtnNXBaj01zV4DKMTou
ICHUjGC3XxMb/IAGcDuZpy+a51XOVi2sSViXl+0fZVY1z9ZnZHZAgbEn5PDW
8Ch6omP76YGzv0bHJB8Jf8XZEruLryTz7G5w+PkQSMTx1ehocz9UjFfAiV0b
9T9MfnVphhvWFbcwicX9ilv1V5SXLjAks7SOfixE4fbGF8NQVJ4S3OqTGovv
rEeQEVjZQA/5Q5QjKlQXZWMLm7ybWGwIoIXDniTD5HlKNGHQ7wUlsdHe8L/c
LW2kmhkEAaKh6PjE+WLO/sqQ7zpEnvo6W3v1VuIR09F+E6eDKsO7zQwZi6Mn
6QMVfI+iQz7U9uRaCuYmae7+SQ6+JR0gThmNYqWpRmOn2TBQ5TsCwKp6EMMT
0EkgKOhAcfRoZD1Fy1pXED4TAi3VOk/8zHQ4YSSSoKPYsJlbpf02kQcPIF7d
e9UsnR1GxW6XGMTp79Hanil9o3k32o9s/392nSleg4po5UH1hgda2XXXWsnT
gHpMB3p5YwOMy3v2T/zMdDhhJJKgo9iwmVul/f/LOaRhg/FAGlWmHFkv4nis
Ki4us1bj9ijM5AEJkGpSBQm1hWRNinQL8IYiYjVQcL8eGyK1EQ0iFOQFlw1L
pSJ9ix7zjP7rVLC18yvBck4v65cYYoYB15Ov0Y3BGXC3b392nSleg4po5UH1
hgda2XWiJECAAHxhZ99Havz6jqKNJrC+Eyu2uiWPFDydKnEnIeWpjzVpRR5J
BvuL5I/vDrtr6RKuscYZtzzsdfl4p+Y7lKN5aC0Q7W7ZRpF4WzdRqEWahyE0
+B6dq4X7zplD1buWoopmlIsfuwSWQD6C4ttw3b2I3ifRBWk5YGV4D3cM3Lf7
eOw2N9iarmFoTfATAiM9MdnZi5caSBzzwdxnF0i9FvLo4d9hsKaFgnXT99iv
1nJtFvDhidY7SoGYSFhVFgfc9RB87CcjpOU6Md6Og//xQryoHZK99aq3N7hQ
ca6qFRIzLE+llFxzt28ph5N8bfQFZ7HKTrCndLHA/EdhI9gvKCe1PpWjOXY+
niJk+8KG0Tk/bB1XqrGm5VpemPoKkiOosPvhacglzjoMQFMqOa4kI+6WWby5
hvFhh19xcx3pcFKzcb8C76jOs7f0P4avtA3QgbTD2B8VAGrRpL/W4INXYIdS
N/WVodbhafs0xbnAz7ZOaMLdmZYrYpJrlM81sgERM/DoN+iT2yz8UCsPoYnl
Hd5Pw0qEYB7bmB6OAXZ1dL1XPCAQYJP/XpvO7D9Fn2A6pTxGf3nuGAnfiTBd
+mMCe59vMD5K1NuZP/Nt1KNJf1zRcqdbUnyDTEfU1YiHM3R0MF1A7vEuj21B
d8eQAcN8aaQU117G6MycI7+vcP2MG+2GtQSAJLSne27I2x9T4ooMSPx+3yVN
bNwNiLR1YwgLZLJ4xDA0Cqp/0PEmbUkuFPyrEaodHImDmUXkWKoS4DyTh99A
NwtpjlZb3OrT93L9FgPmXPLmFftLriZcGrZF1KToa2dsXDclPyl/FltFaFhw
pAk2VVwGfTjDvDbtyug/W2gVW8sOY4AJlEj3VL7aUh3TG1Pp4H6HkILLanv/
7mocXrGfg3ydAdKw5N3VYGXQcdwN2EYplxHbJCrPkCpT3MrJTPlBdPtSpPhb
J9MO7/oUN5+aH82BxaVoe7NvP69wbtWnAxcCjYqtlEQDuDAzQrQZ5qpIKqUJ
okRtB9spOvC1zoBCvD1oDLUGDcGW9hegkJNnr/abxbNva82Tec/EpCIU94Uc
tfptfq8UADrcfNFteqTbvrBwewK0Y6p+m72DgjcDc8F7RfBtnV83h65/z31e
r5N1yCtO6y+DFqwD1ukHS0p0MgWHVkMhrivcVj/ORQq40yhpjqJJlZacG0W2
X2MQzruM7I9B3oDJF9FGtgqi6nO607m7Yo0xjfQCY2iZBHlki7fxp/4tjLuS
hLYebXxasqZ3pQ05mp7AH9gfNpxsKcpoeefSqqVUmdZEgCPNvaG6SbueIxx9
bzDvZeZOOXAEGxe7T2wuBP+w/SGt+E68OA0kkcUGN6/LWA/z+2yd9BoN1VlV
hnMCG6wEB7hUlB9cuypPlnZ0z+LxSvVK29mWoopmlIsfuwSWQD6C4ttw3b2I
3ifRBWk5YGV4D3cM3GitEQT5Pw31DYIA3R5JVGlHGf0dg8v0I6yjO+XFMHVq
4dE6U5wma5tg0/nwXAjxJ4nfJL44P4EnW7Xxl5WRfZ2LJjE3w4sBWxLU2Nrd
wu2vbdskx5qe7U49rYPm6ATM7wLRIwYa74G2IphUjmL/rO/gdx/q6DhR5zVh
JZOx3y+D/zQCF63d+OwzJj3jwb+PNPb1RBQ8WNxNr63pGWAzJ+PvBwjjTCZk
m+iHtlEczovnykigmb5OSyNhis1jar7uIQBy3PlO3hT06FiGYFKZ1BDIbv5l
u5oUxficwufSnTS6U8uqqLjhXMmtScIlS1nI3mA6dgf9R3W6L0hkw561H44Y
RHM7+a4WKj4ss6yjbzy8+mgJuXmJJDurOmoV+3al/5GeHLl///X72onusPD/
Yff0IMLbLkt7iUXbLbdTwjGfhFIWzQAVkV5IDz24Deon5WglJhqfI7r0plcn
Ekhq8RqeTWRfSA/6n8cwJXwrjVmT57JWs8Tqqgpry9sTnu06ZBJCK5g0Nxxk
61LBFGW5BjBMGbY6U0ZKBMw8unW70HqyhLWRmH+rTrEL4NTeEOc7pzEdMJbS
4965KT5RASONCcFfrUBBBCHZY/nVQscRHBJOK1aWW2NqIBMyerNVUPDicGmG
72t0Swb7Aiz8CMO1HX6FE3deTkIm0I2ONtnzyq9yyQxR02AdEmyuDZhFuRNh
fnFNM0OdMiJ321/+JEvq7tvwSoX/CVNuHibxtvhWMDT7Jl4st0NpGFtj0E6R
mOfp8/5pDRuh/27WueMmCQL8bbG5RLQeIIfrQOf0WJFCWGIgF8HCSDGJ+1ef
ksWKxa0e4bd44kLKKJXHj2gl5tu6Hf4pDqdTcgCT3hd30MqxJBqrXuoMSS5g
TE1HFExORWySd7OFHlYrO8Mhkk4px3SyHdj03G7v+6XaPZrm/uJH7eHzGH1N
jK7v9giYzxQalN4W0SJVJJX1GAx3lMMeHb3FXNLknq6YIvqqnQQuT66HZkMJ
fk0xq8Z+6eqRJClif+wC4OWLcG23OGAkfMY1nVkaQQKR2xzwNOK9g0ugXb+W
TO7BdzeSrD3mvCn5+jGy7UqFtEsBBNHfWmMe5CbdMpY8h8Xo9DnBu/Z10oQW
76E5JSgy+xwBtbZqFXAOsba7jfIP8LuEUt9ZED6cOXzXXjGVY7TXwAMIc2WK
PtJOpuMARwrMYTskz1sXb14Ly0qnO3EA+BN1ZViqYgQjW7rkSV9bbCn///IU
87tmsuf4r1EaqiTwPeyrs+LyBtJcf0lS5RCK3cRAp7RDZpZb0Hmp3o0lnB35
syLEG5i5teShV21au7beL2df6NIlE4ANsHMFvisrhlZ+qRQzXDetGHuug9VB
1V6iQOmYQH+d3W7p0FWs8454d2VvOPXUTwyQeeJGg2d32JKiaWzMEwD5NS6+
CTbpBhfq5YSzKm3zAu51TT2exul96j5RAKJhLkJeWSjv4DmaH4eYPWH2bnAM
Hc0kDV5ujELyk8x28dbi+JIqbbtVTQjzafJHuP0jk/rB25Hkytm4nUy3Ae6I
TcfEZkhQdcbo4lje5/Om9PHrz+caMXMOfT5Ydq+Pmsa7n6eQUg9+qcN6JBjA
QJvw4XIP4Dr4MsQrV3SolOaf8+1pinV0CIuH8GAWBc4AAuPfKQM2/Vp0PhWc
ttncE7hiIKuv8hzgYvVW+McFPWwb2WPKyyfzoTZ4Vkjw4kFEpgS0o75jwSgV
22IPx9qVgBAVvPvrdz2hmyX2BnB6kNTeN5xtDJKX87M0Fpv1BDLwe78tqAhQ
Y825eLJnB7TQgUQDz2UojR11OT7I+u7gpcbYoJhrz6diiqS5gqaRApNJWmO4
/ev2fkaZMpPCHuUP0NU1x4S0JXXe5Z/xXaKWHpNG9BCmdmsqbYq0/51ik6Jd
Uh60qgvI8EK3SXpGmR7uWX6HR680SheJzaWTvWYb2PqP1nekq/VZdW6Uweo6
4yy0w72GHpxgzfP/NWsFNO/xi6+J8q3wzJzpmZqoMczkN5cILPsFnOdr/lMM
mz74CZpqNFtCcB82DbV8wXFTA9y0Pia6yWz5D/TwaHUPNVee3K7A1msYt8Pd
DkITdLdDBYO6bX3/H60PQ2A7pEBGUJYek0b0EKZ2ayptirT/nWKkXsept0q7
hP19+40jb3NwllfKKRHQWnOwnAiv04onpvm+v1cCr3OHIsjIIonnfhsMFocz
EDsVPtpvIDsdpu4qSQf5QzZUpdd8iPrGWfuByO8mf/1g3dinHti1EW7k6lMy
p3vp6JlNeNNxgZwOHF/bxoUvdOiudT0o98VJp2A36HgeD38mgZfD6I04h3qO
1mpDcrdWqRThMtmpYbDSUPsNXWUucy0pIhgjjzwWoRqQCmuHyqBntgK3kCCD
yuxnkcINvjU2f/r6TWBJrOrQsjwAUzGustM8TgQkvtTX++Ko+A==
END;

